Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

RECID function

For backward compatibility, the DataServer supports the RECID function for ODBC data-source tables that have a unique 4-byte integer column.

When compatibility is switched on, the Progress-to-ODBC migration utility creates an indexed NUMBER column with unique values for each row called PROGRESS_RECID. You can also add this column to ODBC tables manually if you are using an existing native data source or if you ported an OpenEdge database without compatibility switched on. For instructions, see Appendix A "Upgrading DataServer Applications."

The Data Dictionary automatically designates the column that meets the unique 4-byte integer criteria. You can modify an index in an ODBC data-source table to support RECID. For a complete description of the RECID function, see its reference entry in the OpenEdge Development: Progress 4GL Reference .

You can make an existing application that includes RECID behave more consistently across data sources by replacing RECID with ROWID. See the "ROWID function" section for more information.